Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

OpenEdge database objects and ODBC data-source objects

OpenEdge databases and the ODBC data sources share the structural elements common to relational databases, but each system has its own elements. These elements, called database or data-source objects, are components of the OpenEdge database or ODBC data source’s logical structure. Table 2–1 lists OpenEdge database objects and notes the ODBC data-source equivalents.

Table 2–1: OpenEdge database and ODBC data-source objects (

OpenEdge	DB2	Informix	Sybase
Table	Table	Table	Table
Field	Column	Column	Column
Record	Row	Row	Row
Index	Index	Index	Index
Unique index	Unique key	Primary key	Primary key
Nonunique index	Nonunique key	Nonunique key	Foreign key
Sequences	No equivalent	No equivalent	Native equivalent1
Validation expression	Check constraints	Data integrity	Integrity constraint
Validation message	No equivalent	No equivalent	No equivalent
Initial value	Default	Default	Default
Schema trigger	Trigger	No equivalent	Trigger
No equivalent to stored procedures	Stored procedure	Stored procedure	Stored procedure
View	View	View	View
The DataServer supports Progress 4GL sequences through native stored procedures and triggers.